Setting up to integrate and export to Summit Payroll

 

This topic includes:

How to Install the Integration for Summit Payroll

  1. In PayClock Online, go to Exports > Manage Exports.
  2. Click New, in the list find Evolution.
  3. From Add New Payroll Export select Setup Payroll Export.
  4. Select the pay class(s) to include in the integration and click Next. Note: For multiple pay classes the pay period start and end dates must be the same or the export will have to be done by Date Range.
  5. Enter a nickname and File Name.
  6. Enter the Client Number for Summit Payroll.
  7. Select Export Departments and Export Employee Badge Number if you require that employee data, click Next.
  8. Select the pay codes to map or include in the export and enter the Payroll Pay Type as provided by Summit Payroll, click Next.
  9. Verify the configuration and click Save to complete the integration.
  10. The Summit Payroll integration will show in the list.

How to Export PayClock Online Payroll Data to Summit Payroll

  1. In PayClock Online click on Exports, select the export from the list.
  2. At the export window, select a pay period or date range.
  3. Click Export Data and save the file.
  4. Log into Summit Payroll and follow the steps outlined by your payroll provider.

Note: Please contact your payroll provider if there are any questions when processing your payroll.

How to Read the Output File for Summit Payroll

Field # Field Description Start Position Field Size Format
1 Client Number 1 4  
2 Employee Number 5 5 Required
3 SSN 10 9 N/A
4 Regular Hours 19 8 xxxxx.xx
5 Regular Rate if different 27 8 xxx.xxxx
6 Overtime Hours 35 8 xxxxx.xx
7 Overtime Rate if different 43 8 xxx.xxxx
8 Other Hours 51 8 xxxxx.xx
9 Rate if different 59 8 xxx.xxxx
10 Code for Other Hours 67 3  
11 Salary 70 8 xxxxx.xx
12 Other Earnings 78 8 xxxxx.xx
13 Code for Other Earnings 86 3  
14 Work Comp Code Override 89 5 N/A
15 Work State Override 94 2 N/A
16 Division 96 3 N/A
17 Job Cost Center 99 20 Department No.
18 Clock No. if Employee No. is unknown 119 12 Employee Badge No.
19 Pay Frequency 131 1 N/A

Sample Output File for Evolution

Sample file output with Export Department & Export Employee Badge Number options turned off:

1234,118,,40.00,12.0000,,,,,,,,,,,,0,,

1234,118,,,,1.33,18.0000,,,,,,,,,,0,,

1234,118,,,,,,40.00,12.0000,20,,,,,,,0,,

Sample file output with Export Department option turned on:

1234,118,,40.00,12.0000,,,,,,,,,,,,1011,,

1234,118,,,,1.33,18.0000,,,,,,,,,,1011,,

1234,118,,,,,,40.00,12.0000,20,,,,,,,1011,,

Sample file output with Export Employee Badge Number option turned on:

1234,118,,40.00,12.0000,,,,,,,,,,,,0,4653263,

1234,118,,,,1.33,18.0000,,,,,,,,,,0,4653263,

1234,118,,,,,,40.00,12.0000,20,,,,,,,0,4653263,

 

Wed 12/05/2018